package com.hshx.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hshx.pojo.Salary;
import com.hshx.vo.SalaryVo;

import java.util.List;

public interface SalaryDao extends BaseMapper<Salary>{

    // 添加薪酬标准
    int addStandardCriteria(Salary salary);
    // 根据标准id删除薪酬标准
     int deleteStandardCriteria(Integer salary_id);

    // 根据id集合批量删除
    int deleteStandardCriteriaList(List<String> salary_id_list);
    // 查询所有薪酬标准
    List<Salary> queryStandardCriteria();
    //根据id查询标准
    Salary querySalaryID(Integer salary_id);
    //查询标准编号是否存在
    List<Salary> querySalaryNo(String salary_no);
    //查询标准名称是否存在
    List<Salary> querySalaryName(String salary_name);
    //薪酬标准根据条件搜索
    List<Salary> findCompensationCriteriaSearch(String salary_date,String salary_no,String salary_name);
    //修改薪酬标准
    int updateStandardCriteria(Salary salary);
    //根据id修改薪酬标准状态
    int updateSalaryState(Integer salary_id,Integer salary_state);
    //标准分析
    List<Integer> standardAnalyse1(String date);
}
